How to: Use the SUMPRODUCT() function.
Solution:
Select the cell where the result of the SUMPRODUCT() function is to be displayed. Enter =SUMPRODUCT(<cell range>,<cell range>).
NOTE: The SUMPRODUCT() function multiplies the corresponding components of the specified ranges, adds the results of multiplication, and returns the sum in the selected cell. All the specified cell ranges (arguments) must be the same size and shape. Up to 30 arguments can be entered.
1) Select the cell where the result of the SUMPRODUCT() function is to be displayed.
2) Type an equal sign and the SUMPRODUCT command:
=SUMPRODUCT()
3) Type the arguments within the parentheses of the SUMPRODUCT command.
NOTE: Separate each argument with a comma, no spaces. After a comma has been typed, Excel allows individual cell range to be selected with mouse.
EXAMPLE: The function =SUMPRODUCT(A10:A12,C10:C12), where A10:A12 contains 2, 3, and 4 and C10:C12 contains 4, 5, and 6, results in 47.
4) Press ENTER.
